USE [demo]
GO
/****** Object:  Table [dbo].[EVENT_SCHEME]    Script Date: 06/12/2011 21:13:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EVENT_SCHEME](
	[EVENTSCHEME_ID] [int] IDENTITY(1,1) NOT NULL,
	[EVENTSCHEME_GUID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Table_1_TRACE_GUID]  DEFAULT (newid()),
	[EVENTSCHEME_DATE] [datetime] NOT NULL CONSTRAINT [DF_EVENT_SCHEME_EVENTSCHEME_DATE]  DEFAULT (getdate()),
	[EVENTSCHEME_STATUS] [int] NOT NULL CONSTRAINT [DF_EVENT_SCHEME_EVENTSCHEME_STATUS]  DEFAULT ((0)),
	[EVENT_NAME] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[EVENT_TYPE] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[EVENT_SEVERITY] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[EVENT_CATEGORY] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[SEQ_NAME] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[SEQ_NUMBER] [int] NOT NULL,
	[SEQ_SIZE] [int] NOT NULL,
	[EXECUTABLE] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[FILENAME] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NULL,
	[LINENUMBER] [int] NULL,
	[PROCESS_ID] [int] NULL,
	[THREAD_ID] [int] NULL,
	[CLASS_NAME] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NULL,
	[METHOD_NAME] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[DIRECTION_TYPE] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[MESSAGE_ID] [int] NOT NULL CONSTRAINT [DF_EVENT_SCHEME_MESSAGE_ID]  DEFAULT ((0)),
	[REF_MESSAGE_ID] [int] NOT NULL CONSTRAINT [DF_EVENT_SCHEME_REF_MESSAGE_ID]  DEFAULT ((0))
) ON [PRIMARY]
